﻿
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sproc_RenameTeam]') AND type in (N'P', N'PC'))
    DROP PROCEDURE [dbo].[sproc_RenameTeam];
GO
CREATE PROCEDURE [dbo].[sproc_RenameTeam] 
    @TeamID int,
    @NewClassName nvarchar(300),
    @NewClassRemark ntext
/*

============================================================
功能:    重命名组（类）信息
参数:
    @TeamID int            :    被命名的组（类）ID
    @NewClassName nvarchar(300)    :    组的新名字
    @NewClassRemark ntext    :    组的新介绍

============================================================

*/
AS
IF @TeamID<>1 
    UPDATE uds_class SET classname=@NewClassName,classremark = @NewClassRemark WHERE classid = @TeamID
ELSE
    PRINT 'Can''t rename the deault project.'